﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_GetTaskStatusBySomeone]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_GetTaskStatusBySomeone];
GO
CREATE PROCEDURE [dbo].[sproc_GetTaskStatusBySomeone]
    @TaskID int,
    @Username nvarchar(40)

AS 
select  IsConfirm from uds_schedule where TaskID=@TaskID and Username=@Username